Advanced Excel 2013: Organizing Data

It Works for Me

graphic1

 

graphic2

1. Readings
Read Lesson 1 in the Advanced Excel guide, page 11-44.

Watch the video.

 

Project

A spreadsheet that works with Tables in Excel. This lesson shows how to present data visually, format as a Table and calculate the Totals.

 

Downloads

Sales 2013 Original Data.xlsx

Student Records.xlsx

 

2. Practice

Complete the Practice Activity on page 45.

 

3. Assessment

Review the Test questions on page 46.